package com.iss.lxhproject.dao;


import com.iss.lxhproject.entity.SaleList;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
@Mapper
public interface SaleListDao {
    @Select("select room_type as type,count(room_id)as num,sum(room_price) as money from guest inner join roomfree on room_id = guest_roomid group by room_type;")
    public List<SaleList> selectAll();
}
